package com.example.administrator.myapplication.util;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

/**
 * Created by Administrator on 2020/12/10.
 */

public class DB {

    private Context context;

    //用户登陆时，根据用户输入的姓名学号，查询数据库是否存在
    //select * from account whereusername="" and student_id = "";
    public DB(Context context) {
        this.context = context;
    }

    public boolean loginSelect(String username, String student_id) {
        MyHelper myHelper = new MyHelper(context);
        SQLiteDatabase db = myHelper.getReadableDatabase();
        Cursor cursor = db.rawQuery("select * from account where username=? and student_id = ?", new String[]{username, student_id});
        if (cursor.getCount() != 0) {


            return true;
        } else {
            return false;

        }
    }
//注册
    //insert into account(username,student_id) value(?,?);

    public boolean signInInsert(String username, String student_id) {

        MyHelper myHelper = new MyHelper(context);
        SQLiteDatabase db = myHelper.getWritableDatabase();
        db.execSQL("insert into account(username,student_id) values (?,?),new Object[]{username,student_id}");

        return true;
    }
}